CitiBike Sales Analysis Dashboard

Project information

  • Category: Data Analysis
  • Industry: Urban Planning
  • Data/Study based on: Urban Cycling Organization Data
  • Project date: 10 March, 2025
  • Project URL: Github Link
  • Skills: Google Looker | Snowflake | SQL | Excel | Data Analysis | Customer Analysis | Market Research | Domain Understanding

An analysis of cycling trends

Analyzed 23M+ Citi Bike trips (2020-2024) to uncover usage trends and demographics using Snowflake and Looker Studio.

Loaded data with custom CSV file formats, performed SQL aggregations, and utilized Time Travel in Snowflake with the COMPUTE_WH warehouse.

Designed Looker Studio dashboards featuring time series, pie charts, and stacked bars for interactive trip pattern visualization.